In [10]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
from plotly.offline import download_plotlyjs,init_notebook_mode,plot,iplot
%matplotlib inline

import cufflinks as cf
In [11]:
init_notebook_mode(connected=True)
In [12]:
cf.go_offline()
In [13]:
df = pd.read_csv(r"C:\Users\HP\Downloads\Dataset\911.csv")
In [14]:
df
Out[14]:
lat lng desc zip title timeStamp twp addr e
0 40.297876 -75.581294 REINDEER CT & DEAD END; NEW HANOVER; Station ... 19525.0 EMS: BACK PAINS/INJURY 2015-12-10 17:10:52 NEW HANOVER REINDEER CT & DEAD END 1
1 40.258061 -75.264680 BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... 19446.0 EMS: DIABETIC EMERGENCY 2015-12-10 17:29:21 HATFIELD TOWNSHIP BRIAR PATH & WHITEMARSH LN 1
2 40.121182 -75.351975 HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... 19401.0 Fire: GAS-ODOR/LEAK 2015-12-10 14:39:21 NORRISTOWN HAWS AVE 1
3 40.116153 -75.343513 AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... 19401.0 EMS: CARDIAC EMERGENCY 2015-12-10 16:47:36 NORRISTOWN AIRY ST & SWEDE ST 1
4 40.251492 -75.603350 CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... NaN EMS: DIZZINESS 2015-12-10 16:56:52 LOWER POTTSGROVE CHERRYWOOD CT & DEAD END 1
5 40.253473 -75.283245 CANNON AVE & W 9TH ST; LANSDALE; Station 345;... 19446.0 EMS: HEAD INJURY 2015-12-10 15:39:04 LANSDALE CANNON AVE & W 9TH ST 1
6 40.182111 -75.127795 LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... 19044.0 EMS: NAUSEA/VOMITING 2015-12-10 16:46:48 HORSHAM LAUREL AVE & OAKDALE AVE 1
7 40.217286 -75.405182 COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... 19426.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 16:17:05 SKIPPACK COLLEGEVILLE RD & LYWISKI RD 1
8 40.289027 -75.399590 MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... 19438.0 EMS: SYNCOPAL EPISODE 2015-12-10 16:51:42 LOWER SALFORD MAIN ST & OLD SUMNEYTOWN PIKE 1
9 40.102398 -75.291458 BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... 19462.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:35:41 PLYMOUTH BLUEROUTE & RAMP I476 NB TO CHEMICAL RD 1
10 40.231990 -75.251891 RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:33:50 MONTGOMERY RT202 PKWY & KNAPP RD 1
11 40.084161 -75.308386 BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... 19428.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 16:32:10 PLYMOUTH BROOK RD & COLWELL LN 1
12 40.174131 -75.098491 BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... 19040.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:15:49 UPPER MORELAND BYBERRY AVE & S WARMINSTER RD 1
13 40.062974 -75.135914 OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... 19027.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:12:47 CHELTENHAM OLD YORK RD & VALLEY RD 1
14 40.097222 -75.376195 SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:09:49 UPPER MERION SCHUYLKILL EXPY & CROTON RD UNDERPASS 1
15 40.223778 -75.235399 STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... 18936.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:31:00 MONTGOMERY STUMP RD & WITCHWOOD DR 1
16 40.243258 -75.286552 SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... 19446.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 17:42:44 LANSDALE SUSQUEHANNA AVE & W MAIN ST 1
17 40.312181 -75.574260 CHARLOTTE ST & MILES RD; NEW HANOVER; Station... 19525.0 EMS: DIZZINESS 2015-12-10 17:41:54 NEW HANOVER CHARLOTTE ST & MILES RD 1
18 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... 19401.0 EMS: VEHICLE ACCIDENT 2015-12-10 17:43:29 NORRISTOWN PENN ST & ARCH ST 1
19 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:45:23 HORSHAM COUNTY LINE RD & WILLOW DR 1
20 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... 19401.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:43:45 NORRISTOWN PENN ST & ARCH ST 1
21 40.117948 -75.209848 CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... 19031.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:53:22 WHITEMARSH CHURCH RD & REDCOAT DR 1
22 40.199006 -75.300058 LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... 19446.0 Fire: APPLIANCE FIRE 2015-12-10 17:59:24 UPPER GWYNEDD LILAC CT & PRIMROSE DR 1
23 40.143326 -75.422819 RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... NaN Traffic: DISABLED VEHICLE - 2015-12-10 18:00:38 LOWER PROVIDENCE RT422 & PAWLINGS RD OVERPASS 1
24 40.153268 -75.189558 SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:58:22 UPPER DUBLIN SUMMIT AVE & RT309 UNDERPASS 1
25 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: GENERAL WEAKNESS 2015-12-10 18:02:02 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1
26 40.155283 -75.264230 PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... 19422.0 EMS: HEAD INJURY 2015-12-10 18:02:38 WHITPAIN PENLLYN BLUE BELL PIKE & VILLAGE CIR 1
27 40.028903 -75.351822 EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... 19085.0 Fire: CARBON MONOXIDE DETECTOR 2015-12-10 18:05:19 DELAWARE COUNTY EDENTON PL & DURHAM DR 1
28 40.097222 -75.376195 SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 18:05:39 UPPER MERION SCHUYLKILL EXPY & WEADLEY RD OVERPASS 1
29 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 18:10:40 HORSHAM COUNTY LINE RD & WILLOW DR 1
... ... ... ... ... ... ... ... ... ...
423879 40.284894 -75.583070 BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... 19525.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:18:15 NEW HANOVER BUCHERT RD & ROMIG RD 1
423880 40.089043 -75.154857 RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... 19095.0 Traffic: ROAD OBSTRUCTION - 2018-11-16 08:18:08 CHELTENHAM RICES MILL RD & W CHURCH RD 1
423881 40.188195 -75.195506 TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:17:59 HORSHAM TENNIS AVE & WELSH RD 1
423882 40.188195 -75.195506 WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:14:32 UPPER DUBLIN WELSH RD & TENNIS AVE 1
423883 40.175671 -75.125148 SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... 19044.0 EMS: SUBJECT IN PAIN 2018-11-16 08:27:45 HORSHAM SUMMIT AVE & RUTH AVE 1
423884 40.277468 -75.260462 BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... 19440.0 Fire: FIRE INVESTIGATION 2018-11-16 08:30:54 HATFIELD TOWNSHIP BETHLEHEM PIKE & TREWIGTOWN RD 1
423885 40.345292 -75.509276 HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... 18054.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:29:22 NEW HANOVER HENNING RD & HILL RD 1
423886 40.260591 -75.503238 YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... 19473.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:30:00 LOWER FREDERICK YERGER RD & N RYANFORD RD 1
423887 40.136020 -75.354606 BEECH DR & SPRUCE ST; WEST NORRITON; Station ... 19403.0 EMS: SEIZURES 2018-11-16 08:39:28 WEST NORRITON BEECH DR & SPRUCE ST 1
423888 40.230934 -75.522125 LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... 19468.0 Fire: FIRE ALARM 2018-11-16 08:39:53 LIMERICK LIGHTCAP RD & SANATOGA SPRINGS DR 1
423889 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER MORELAND MORELAND RD & BARTRAM RD 1
423890 40.335354 -75.511268 HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... 18074.0 Fire: FIRE POLICE NEEDED 2018-11-16 08:45:04 NEW HANOVER HENNING RD 1
423891 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER MORELAND MORELAND RD & BARTRAM RD 1
423892 40.107400 -75.113206 THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... 19046.0 Fire: FIRE ALARM 2018-11-16 08:49:48 ABINGTON THE FAIRWAY & RYDAL RD 1
423893 40.256628 -75.261270 LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... 19446.0 Fire: FIRE INVESTIGATION 2018-11-16 08:48:24 HATFIELD TOWNSHIP LINE ST & COWPATH RD 1
423894 40.183361 -75.542285 MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... 19468.0 EMS: FALL VICTIM 2018-11-16 08:50:58 ROYERSFORD MAIN ST & 2ND AVE 1
423895 40.184797 -75.286879 TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... 19422.0 EMS: SYNCOPAL EPISODE 2018-11-16 08:47:05 WHITPAIN TWIN SILO DR & MORRIS RD 1
423896 40.254344 -75.407617 HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; NaN Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 UPPER SALFORD HOFFMAN 1
423897 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1
423898 40.142797 -75.495065 MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... 19460.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:43:42 UPPER PROVIDENCE MAC DADE RD & SCARLET OAK DR 1
423899 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1
423900 40.157913 -75.203632 HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; 19002.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 AMBLER HOFFMAN 1
423901 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: MEDICAL ALERT ALARM 2018-11-16 08:53:03 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1
423902 40.271663 -75.238440 RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... 18914.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:55:36 MONTGOMERY RICHARDSON RD & COUNTY LINE RD 1
423903 40.235373 -75.224751 HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... 19454.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:54:52 MONTGOMERY HORSHAM RD & STUMP RD 1
423904 40.139993 -75.049864 BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... 19006.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:08 LOWER MORELAND BUCK RD & WOODWARD DR 1
423905 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:53:32 LOWER SALFORD OAK DR & MOYER RD 1
423906 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:19 LOWER SALFORD OAK DR & MOYER RD 1
423907 40.190946 -75.237285 SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:51:48 LOWER GWYNEDD SUMNEYTOWN PIKE & WELLINGTON DR 1
423908 40.155164 -75.264665 HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; 19422.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 LOWER GWYNEDD HOFFMAN 1

423909 rows × 9 columns

In [15]:
df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 423909 entries, 0 to 423908
Data columns (total 9 columns):
lat          423909 non-null float64
lng          423909 non-null float64
desc         423909 non-null object
zip          371780 non-null float64
title        423909 non-null object
timeStamp    423909 non-null object
twp          423750 non-null object
addr         423909 non-null object
e            423909 non-null int64
dtypes: float64(3), int64(1), object(5)
memory usage: 29.1+ MB
In [16]:
df["twp"].value_counts().head(10)
Out[16]:
LOWER MERION        36441
ABINGTON            25835
NORRISTOWN          23883
UPPER MERION        22694
CHELTENHAM          19629
POTTSTOWN           17500
UPPER MORELAND      14707
LOWER PROVIDENCE    14025
PLYMOUTH            12800
UPPER DUBLIN        11910
Name: twp, dtype: int64
In [17]:
df["timeStamp"] = pd.to_datetime(df["timeStamp"])
In [18]:
df["timeStamp"].value_counts().head(10)
Out[18]:
2018-10-06 19:26:38    9
2018-07-09 13:23:16    8
2017-02-09 07:17:58    6
2016-06-01 16:34:27    6
2016-07-10 19:00:45    6
2016-07-20 06:42:37    6
2018-11-03 10:35:24    5
2017-03-05 09:02:35    5
2015-12-12 05:22:51    5
2017-05-29 12:22:45    5
Name: timeStamp, dtype: int64
In [19]:
df["title"].nunique()
Out[19]:
141
In [20]:
df["title"].head(10)
Out[20]:
0         EMS: BACK PAINS/INJURY
1        EMS: DIABETIC EMERGENCY
2            Fire: GAS-ODOR/LEAK
3         EMS: CARDIAC EMERGENCY
4                 EMS: DIZZINESS
5               EMS: HEAD INJURY
6           EMS: NAUSEA/VOMITING
7     EMS: RESPIRATORY EMERGENCY
8          EMS: SYNCOPAL EPISODE
9    Traffic: VEHICLE ACCIDENT -
Name: title, dtype: object
In [21]:
df["short"] = df["title"].apply(lambda x:x.split(":")[0])
In [22]:
df["short"].head(10)
Out[22]:
0        EMS
1        EMS
2       Fire
3        EMS
4        EMS
5        EMS
6        EMS
7        EMS
8        EMS
9    Traffic
Name: short, dtype: object
In [23]:
df
Out[23]:
lat lng desc zip title timeStamp twp addr e short
0 40.297876 -75.581294 REINDEER CT & DEAD END; NEW HANOVER; Station ... 19525.0 EMS: BACK PAINS/INJURY 2015-12-10 17:10:52 NEW HANOVER REINDEER CT & DEAD END 1 EMS
1 40.258061 -75.264680 BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... 19446.0 EMS: DIABETIC EMERGENCY 2015-12-10 17:29:21 HATFIELD TOWNSHIP BRIAR PATH & WHITEMARSH LN 1 EMS
2 40.121182 -75.351975 HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... 19401.0 Fire: GAS-ODOR/LEAK 2015-12-10 14:39:21 NORRISTOWN HAWS AVE 1 Fire
3 40.116153 -75.343513 AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... 19401.0 EMS: CARDIAC EMERGENCY 2015-12-10 16:47:36 NORRISTOWN AIRY ST & SWEDE ST 1 EMS
4 40.251492 -75.603350 CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... NaN EMS: DIZZINESS 2015-12-10 16:56:52 LOWER POTTSGROVE CHERRYWOOD CT & DEAD END 1 EMS
5 40.253473 -75.283245 CANNON AVE & W 9TH ST; LANSDALE; Station 345;... 19446.0 EMS: HEAD INJURY 2015-12-10 15:39:04 LANSDALE CANNON AVE & W 9TH ST 1 EMS
6 40.182111 -75.127795 LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... 19044.0 EMS: NAUSEA/VOMITING 2015-12-10 16:46:48 HORSHAM LAUREL AVE & OAKDALE AVE 1 EMS
7 40.217286 -75.405182 COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... 19426.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 16:17:05 SKIPPACK COLLEGEVILLE RD & LYWISKI RD 1 EMS
8 40.289027 -75.399590 MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... 19438.0 EMS: SYNCOPAL EPISODE 2015-12-10 16:51:42 LOWER SALFORD MAIN ST & OLD SUMNEYTOWN PIKE 1 EMS
9 40.102398 -75.291458 BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... 19462.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:35:41 PLYMOUTH BLUEROUTE & RAMP I476 NB TO CHEMICAL RD 1 Traffic
10 40.231990 -75.251891 RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:33:50 MONTGOMERY RT202 PKWY & KNAPP RD 1 Traffic
11 40.084161 -75.308386 BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... 19428.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 16:32:10 PLYMOUTH BROOK RD & COLWELL LN 1 Traffic
12 40.174131 -75.098491 BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... 19040.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:15:49 UPPER MORELAND BYBERRY AVE & S WARMINSTER RD 1 Traffic
13 40.062974 -75.135914 OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... 19027.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:12:47 CHELTENHAM OLD YORK RD & VALLEY RD 1 Traffic
14 40.097222 -75.376195 SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:09:49 UPPER MERION SCHUYLKILL EXPY & CROTON RD UNDERPASS 1 Traffic
15 40.223778 -75.235399 STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... 18936.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:31:00 MONTGOMERY STUMP RD & WITCHWOOD DR 1 Traffic
16 40.243258 -75.286552 SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... 19446.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 17:42:44 LANSDALE SUSQUEHANNA AVE & W MAIN ST 1 EMS
17 40.312181 -75.574260 CHARLOTTE ST & MILES RD; NEW HANOVER; Station... 19525.0 EMS: DIZZINESS 2015-12-10 17:41:54 NEW HANOVER CHARLOTTE ST & MILES RD 1 EMS
18 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... 19401.0 EMS: VEHICLE ACCIDENT 2015-12-10 17:43:29 NORRISTOWN PENN ST & ARCH ST 1 EMS
19 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:45:23 HORSHAM COUNTY LINE RD & WILLOW DR 1 Traffic
20 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... 19401.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:43:45 NORRISTOWN PENN ST & ARCH ST 1 Traffic
21 40.117948 -75.209848 CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... 19031.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:53:22 WHITEMARSH CHURCH RD & REDCOAT DR 1 Traffic
22 40.199006 -75.300058 LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... 19446.0 Fire: APPLIANCE FIRE 2015-12-10 17:59:24 UPPER GWYNEDD LILAC CT & PRIMROSE DR 1 Fire
23 40.143326 -75.422819 RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... NaN Traffic: DISABLED VEHICLE - 2015-12-10 18:00:38 LOWER PROVIDENCE RT422 & PAWLINGS RD OVERPASS 1 Traffic
24 40.153268 -75.189558 SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:58:22 UPPER DUBLIN SUMMIT AVE & RT309 UNDERPASS 1 Traffic
25 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: GENERAL WEAKNESS 2015-12-10 18:02:02 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1 EMS
26 40.155283 -75.264230 PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... 19422.0 EMS: HEAD INJURY 2015-12-10 18:02:38 WHITPAIN PENLLYN BLUE BELL PIKE & VILLAGE CIR 1 EMS
27 40.028903 -75.351822 EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... 19085.0 Fire: CARBON MONOXIDE DETECTOR 2015-12-10 18:05:19 DELAWARE COUNTY EDENTON PL & DURHAM DR 1 Fire
28 40.097222 -75.376195 SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 18:05:39 UPPER MERION SCHUYLKILL EXPY & WEADLEY RD OVERPASS 1 Traffic
29 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 18:10:40 HORSHAM COUNTY LINE RD & WILLOW DR 1 Traffic
... ... ... ... ... ... ... ... ... ... ...
423879 40.284894 -75.583070 BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... 19525.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:18:15 NEW HANOVER BUCHERT RD & ROMIG RD 1 Traffic
423880 40.089043 -75.154857 RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... 19095.0 Traffic: ROAD OBSTRUCTION - 2018-11-16 08:18:08 CHELTENHAM RICES MILL RD & W CHURCH RD 1 Traffic
423881 40.188195 -75.195506 TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:17:59 HORSHAM TENNIS AVE & WELSH RD 1 Traffic
423882 40.188195 -75.195506 WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:14:32 UPPER DUBLIN WELSH RD & TENNIS AVE 1 Traffic
423883 40.175671 -75.125148 SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... 19044.0 EMS: SUBJECT IN PAIN 2018-11-16 08:27:45 HORSHAM SUMMIT AVE & RUTH AVE 1 EMS
423884 40.277468 -75.260462 BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... 19440.0 Fire: FIRE INVESTIGATION 2018-11-16 08:30:54 HATFIELD TOWNSHIP BETHLEHEM PIKE & TREWIGTOWN RD 1 Fire
423885 40.345292 -75.509276 HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... 18054.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:29:22 NEW HANOVER HENNING RD & HILL RD 1 Traffic
423886 40.260591 -75.503238 YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... 19473.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:30:00 LOWER FREDERICK YERGER RD & N RYANFORD RD 1 Traffic
423887 40.136020 -75.354606 BEECH DR & SPRUCE ST; WEST NORRITON; Station ... 19403.0 EMS: SEIZURES 2018-11-16 08:39:28 WEST NORRITON BEECH DR & SPRUCE ST 1 EMS
423888 40.230934 -75.522125 LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... 19468.0 Fire: FIRE ALARM 2018-11-16 08:39:53 LIMERICK LIGHTCAP RD & SANATOGA SPRINGS DR 1 Fire
423889 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER MORELAND MORELAND RD & BARTRAM RD 1 Traffic
423890 40.335354 -75.511268 HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... 18074.0 Fire: FIRE POLICE NEEDED 2018-11-16 08:45:04 NEW HANOVER HENNING RD 1 Fire
423891 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER MORELAND MORELAND RD & BARTRAM RD 1 Traffic
423892 40.107400 -75.113206 THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... 19046.0 Fire: FIRE ALARM 2018-11-16 08:49:48 ABINGTON THE FAIRWAY & RYDAL RD 1 Fire
423893 40.256628 -75.261270 LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... 19446.0 Fire: FIRE INVESTIGATION 2018-11-16 08:48:24 HATFIELD TOWNSHIP LINE ST & COWPATH RD 1 Fire
423894 40.183361 -75.542285 MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... 19468.0 EMS: FALL VICTIM 2018-11-16 08:50:58 ROYERSFORD MAIN ST & 2ND AVE 1 EMS
423895 40.184797 -75.286879 TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... 19422.0 EMS: SYNCOPAL EPISODE 2018-11-16 08:47:05 WHITPAIN TWIN SILO DR & MORRIS RD 1 EMS
423896 40.254344 -75.407617 HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; NaN Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 UPPER SALFORD HOFFMAN 1 Traffic
423897 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1 Traffic
423898 40.142797 -75.495065 MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... 19460.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:43:42 UPPER PROVIDENCE MAC DADE RD & SCARLET OAK DR 1 Traffic
423899 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1 Traffic
423900 40.157913 -75.203632 HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; 19002.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 AMBLER HOFFMAN 1 Traffic
423901 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: MEDICAL ALERT ALARM 2018-11-16 08:53:03 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1 EMS
423902 40.271663 -75.238440 RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... 18914.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:55:36 MONTGOMERY RICHARDSON RD & COUNTY LINE RD 1 Traffic
423903 40.235373 -75.224751 HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... 19454.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:54:52 MONTGOMERY HORSHAM RD & STUMP RD 1 Traffic
423904 40.139993 -75.049864 BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... 19006.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:08 LOWER MORELAND BUCK RD & WOODWARD DR 1 Traffic
423905 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:53:32 LOWER SALFORD OAK DR & MOYER RD 1 Traffic
423906 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:19 LOWER SALFORD OAK DR & MOYER RD 1 Traffic
423907 40.190946 -75.237285 SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:51:48 LOWER GWYNEDD SUMNEYTOWN PIKE & WELLINGTON DR 1 Traffic
423908 40.155164 -75.264665 HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; 19422.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 LOWER GWYNEDD HOFFMAN 1 Traffic

423909 rows × 10 columns

In [24]:
df["short"].value_counts().head()
Out[24]:
EMS        208676
Traffic    151458
Fire        63775
Name: short, dtype: int64
In [91]:
sns.countplot(x="short", data=df, palette="Set2")
plt.tight_layout(rect=[0, 0.02, 3, 2])
In [26]:
df["hour"] = df["timeStamp"].apply(lambda x:x.hour)
In [27]:
df["hour"].value_counts().head(10)
Out[27]:
17    27933
16    27738
15    26976
14    25836
12    25486
13    25460
11    24263
18    24071
10    23334
9     22715
Name: hour, dtype: int64
In [28]:
df["months"] = df["timeStamp"].apply(lambda x:x.month)
In [29]:
df["months"].value_counts().head(10)
Out[29]:
1     37824
10    37815
3     37666
7     36405
6     36171
8     35972
5     35644
9     35339
4     33583
12    33019
Name: months, dtype: int64
In [30]:
df["day"] = df["timeStamp"].apply(lambda x:x.dayofweek)
In [31]:
df["day"].value_counts()
Out[31]:
4    65751
2    63423
3    63159
1    63041
0    61318
5    57093
6    50124
Name: day, dtype: int64
In [32]:
df
Out[32]:
lat lng desc zip title timeStamp twp addr e short hour months day
0 40.297876 -75.581294 REINDEER CT & DEAD END; NEW HANOVER; Station ... 19525.0 EMS: BACK PAINS/INJURY 2015-12-10 17:10:52 NEW HANOVER REINDEER CT & DEAD END 1 EMS 17 12 3
1 40.258061 -75.264680 BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... 19446.0 EMS: DIABETIC EMERGENCY 2015-12-10 17:29:21 HATFIELD TOWNSHIP BRIAR PATH & WHITEMARSH LN 1 EMS 17 12 3
2 40.121182 -75.351975 HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... 19401.0 Fire: GAS-ODOR/LEAK 2015-12-10 14:39:21 NORRISTOWN HAWS AVE 1 Fire 14 12 3
3 40.116153 -75.343513 AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... 19401.0 EMS: CARDIAC EMERGENCY 2015-12-10 16:47:36 NORRISTOWN AIRY ST & SWEDE ST 1 EMS 16 12 3
4 40.251492 -75.603350 CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... NaN EMS: DIZZINESS 2015-12-10 16:56:52 LOWER POTTSGROVE CHERRYWOOD CT & DEAD END 1 EMS 16 12 3
5 40.253473 -75.283245 CANNON AVE & W 9TH ST; LANSDALE; Station 345;... 19446.0 EMS: HEAD INJURY 2015-12-10 15:39:04 LANSDALE CANNON AVE & W 9TH ST 1 EMS 15 12 3
6 40.182111 -75.127795 LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... 19044.0 EMS: NAUSEA/VOMITING 2015-12-10 16:46:48 HORSHAM LAUREL AVE & OAKDALE AVE 1 EMS 16 12 3
7 40.217286 -75.405182 COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... 19426.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 16:17:05 SKIPPACK COLLEGEVILLE RD & LYWISKI RD 1 EMS 16 12 3
8 40.289027 -75.399590 MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... 19438.0 EMS: SYNCOPAL EPISODE 2015-12-10 16:51:42 LOWER SALFORD MAIN ST & OLD SUMNEYTOWN PIKE 1 EMS 16 12 3
9 40.102398 -75.291458 BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... 19462.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:35:41 PLYMOUTH BLUEROUTE & RAMP I476 NB TO CHEMICAL RD 1 Traffic 17 12 3
10 40.231990 -75.251891 RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:33:50 MONTGOMERY RT202 PKWY & KNAPP RD 1 Traffic 17 12 3
11 40.084161 -75.308386 BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... 19428.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 16:32:10 PLYMOUTH BROOK RD & COLWELL LN 1 Traffic 16 12 3
12 40.174131 -75.098491 BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... 19040.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:15:49 UPPER MORELAND BYBERRY AVE & S WARMINSTER RD 1 Traffic 17 12 3
13 40.062974 -75.135914 OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... 19027.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:12:47 CHELTENHAM OLD YORK RD & VALLEY RD 1 Traffic 17 12 3
14 40.097222 -75.376195 SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:09:49 UPPER MERION SCHUYLKILL EXPY & CROTON RD UNDERPASS 1 Traffic 17 12 3
15 40.223778 -75.235399 STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... 18936.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:31:00 MONTGOMERY STUMP RD & WITCHWOOD DR 1 Traffic 17 12 3
16 40.243258 -75.286552 SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... 19446.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 17:42:44 LANSDALE SUSQUEHANNA AVE & W MAIN ST 1 EMS 17 12 3
17 40.312181 -75.574260 CHARLOTTE ST & MILES RD; NEW HANOVER; Station... 19525.0 EMS: DIZZINESS 2015-12-10 17:41:54 NEW HANOVER CHARLOTTE ST & MILES RD 1 EMS 17 12 3
18 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... 19401.0 EMS: VEHICLE ACCIDENT 2015-12-10 17:43:29 NORRISTOWN PENN ST & ARCH ST 1 EMS 17 12 3
19 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:45:23 HORSHAM COUNTY LINE RD & WILLOW DR 1 Traffic 17 12 3
20 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... 19401.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:43:45 NORRISTOWN PENN ST & ARCH ST 1 Traffic 17 12 3
21 40.117948 -75.209848 CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... 19031.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:53:22 WHITEMARSH CHURCH RD & REDCOAT DR 1 Traffic 17 12 3
22 40.199006 -75.300058 LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... 19446.0 Fire: APPLIANCE FIRE 2015-12-10 17:59:24 UPPER GWYNEDD LILAC CT & PRIMROSE DR 1 Fire 17 12 3
23 40.143326 -75.422819 RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... NaN Traffic: DISABLED VEHICLE - 2015-12-10 18:00:38 LOWER PROVIDENCE RT422 & PAWLINGS RD OVERPASS 1 Traffic 18 12 3
24 40.153268 -75.189558 SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:58:22 UPPER DUBLIN SUMMIT AVE & RT309 UNDERPASS 1 Traffic 17 12 3
25 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: GENERAL WEAKNESS 2015-12-10 18:02:02 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1 EMS 18 12 3
26 40.155283 -75.264230 PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... 19422.0 EMS: HEAD INJURY 2015-12-10 18:02:38 WHITPAIN PENLLYN BLUE BELL PIKE & VILLAGE CIR 1 EMS 18 12 3
27 40.028903 -75.351822 EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... 19085.0 Fire: CARBON MONOXIDE DETECTOR 2015-12-10 18:05:19 DELAWARE COUNTY EDENTON PL & DURHAM DR 1 Fire 18 12 3
28 40.097222 -75.376195 SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 18:05:39 UPPER MERION SCHUYLKILL EXPY & WEADLEY RD OVERPASS 1 Traffic 18 12 3
29 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 18:10:40 HORSHAM COUNTY LINE RD & WILLOW DR 1 Traffic 18 12 3
... ... ... ... ... ... ... ... ... ... ... ... ... ...
423879 40.284894 -75.583070 BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... 19525.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:18:15 NEW HANOVER BUCHERT RD & ROMIG RD 1 Traffic 8 11 4
423880 40.089043 -75.154857 RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... 19095.0 Traffic: ROAD OBSTRUCTION - 2018-11-16 08:18:08 CHELTENHAM RICES MILL RD & W CHURCH RD 1 Traffic 8 11 4
423881 40.188195 -75.195506 TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:17:59 HORSHAM TENNIS AVE & WELSH RD 1 Traffic 8 11 4
423882 40.188195 -75.195506 WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:14:32 UPPER DUBLIN WELSH RD & TENNIS AVE 1 Traffic 8 11 4
423883 40.175671 -75.125148 SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... 19044.0 EMS: SUBJECT IN PAIN 2018-11-16 08:27:45 HORSHAM SUMMIT AVE & RUTH AVE 1 EMS 8 11 4
423884 40.277468 -75.260462 BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... 19440.0 Fire: FIRE INVESTIGATION 2018-11-16 08:30:54 HATFIELD TOWNSHIP BETHLEHEM PIKE & TREWIGTOWN RD 1 Fire 8 11 4
423885 40.345292 -75.509276 HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... 18054.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:29:22 NEW HANOVER HENNING RD & HILL RD 1 Traffic 8 11 4
423886 40.260591 -75.503238 YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... 19473.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:30:00 LOWER FREDERICK YERGER RD & N RYANFORD RD 1 Traffic 8 11 4
423887 40.136020 -75.354606 BEECH DR & SPRUCE ST; WEST NORRITON; Station ... 19403.0 EMS: SEIZURES 2018-11-16 08:39:28 WEST NORRITON BEECH DR & SPRUCE ST 1 EMS 8 11 4
423888 40.230934 -75.522125 LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... 19468.0 Fire: FIRE ALARM 2018-11-16 08:39:53 LIMERICK LIGHTCAP RD & SANATOGA SPRINGS DR 1 Fire 8 11 4
423889 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER MORELAND MORELAND RD & BARTRAM RD 1 Traffic 8 11 4
423890 40.335354 -75.511268 HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... 18074.0 Fire: FIRE POLICE NEEDED 2018-11-16 08:45:04 NEW HANOVER HENNING RD 1 Fire 8 11 4
423891 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER MORELAND MORELAND RD & BARTRAM RD 1 Traffic 8 11 4
423892 40.107400 -75.113206 THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... 19046.0 Fire: FIRE ALARM 2018-11-16 08:49:48 ABINGTON THE FAIRWAY & RYDAL RD 1 Fire 8 11 4
423893 40.256628 -75.261270 LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... 19446.0 Fire: FIRE INVESTIGATION 2018-11-16 08:48:24 HATFIELD TOWNSHIP LINE ST & COWPATH RD 1 Fire 8 11 4
423894 40.183361 -75.542285 MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... 19468.0 EMS: FALL VICTIM 2018-11-16 08:50:58 ROYERSFORD MAIN ST & 2ND AVE 1 EMS 8 11 4
423895 40.184797 -75.286879 TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... 19422.0 EMS: SYNCOPAL EPISODE 2018-11-16 08:47:05 WHITPAIN TWIN SILO DR & MORRIS RD 1 EMS 8 11 4
423896 40.254344 -75.407617 HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; NaN Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 UPPER SALFORD HOFFMAN 1 Traffic 8 11 4
423897 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1 Traffic 8 11 4
423898 40.142797 -75.495065 MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... 19460.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:43:42 UPPER PROVIDENCE MAC DADE RD & SCARLET OAK DR 1 Traffic 8 11 4
423899 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1 Traffic 8 11 4
423900 40.157913 -75.203632 HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; 19002.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 AMBLER HOFFMAN 1 Traffic 8 11 4
423901 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: MEDICAL ALERT ALARM 2018-11-16 08:53:03 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1 EMS 8 11 4
423902 40.271663 -75.238440 RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... 18914.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:55:36 MONTGOMERY RICHARDSON RD & COUNTY LINE RD 1 Traffic 8 11 4
423903 40.235373 -75.224751 HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... 19454.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:54:52 MONTGOMERY HORSHAM RD & STUMP RD 1 Traffic 8 11 4
423904 40.139993 -75.049864 BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... 19006.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:08 LOWER MORELAND BUCK RD & WOODWARD DR 1 Traffic 8 11 4
423905 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:53:32 LOWER SALFORD OAK DR & MOYER RD 1 Traffic 8 11 4
423906 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:19 LOWER SALFORD OAK DR & MOYER RD 1 Traffic 8 11 4
423907 40.190946 -75.237285 SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:51:48 LOWER GWYNEDD SUMNEYTOWN PIKE & WELLINGTON DR 1 Traffic 8 11 4
423908 40.155164 -75.264665 HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; 19422.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 LOWER GWYNEDD HOFFMAN 1 Traffic 8 11 4

423909 rows × 13 columns

In [33]:
mapping = {1:"MON",2:"TUE",3:"WED",4:"THU",5:"FRI",6:"SAT",7:"SUN"}

daysofweek = df["day"].map(mapping)
In [34]:
daysofweek.value_counts()
Out[34]:
THU    65751
TUE    63423
WED    63159
MON    63041
FRI    57093
SAT    50124
Name: day, dtype: int64
In [90]:
sns.countplot(x=daysofweek,data=df,hue="short", palette="Set2")
plt.tight_layout(rect=[0, 0.02, 3, 2])
In [36]:
bymonth = df.groupby(df["months"]).count()
In [37]:
bymonth
Out[37]:
lat lng desc zip title timeStamp twp addr e short hour months day
months
1 37824 37824 37824 33480 37824 37824 37812 37824 37824 37824 37824 37824 37824
2 32828 32828 32828 28963 32828 32828 32817 32828 32828 32828 32828 32828 32828
3 37666 37666 37666 33416 37666 37666 37651 37666 37666 37666 37666 37666 37666
4 33583 33583 33583 29488 33583 33583 33575 33583 33583 33583 33583 33583 33583
5 35644 35644 35644 31114 35644 35644 35628 35644 35644 35644 35644 35644 35644
6 36171 36171 36171 31501 36171 36171 36152 36171 36171 36171 36171 36171 36171
7 36405 36405 36405 31863 36405 36405 36391 36405 36405 36405 36405 36405 36405
8 35972 35972 35972 31512 35972 35972 35957 35972 35972 35972 35972 35972 35972
9 35339 35339 35339 30772 35339 35339 35325 35339 35339 35339 35339 35339 35339
10 37815 37815 37815 32919 37815 37815 37809 37815 37815 37815 37815 37815 37815
11 31643 31643 31643 27776 31643 31643 31628 31643 31643 31643 31643 31643 31643
12 33019 33019 33019 28976 33019 33019 33005 33019 33019 33019 33019 33019 33019
In [94]:
bymonth["months"].iplot(linewidth=5, color='red')
plt.tight_layout(rect=[0, 0.02, 3, 1])
<matplotlib.figure.Figure at 0x294cbf87c18>
In [40]:
df
Out[40]:
lat lng desc zip title timeStamp twp addr e short hour months day
0 40.297876 -75.581294 REINDEER CT & DEAD END; NEW HANOVER; Station ... 19525.0 EMS: BACK PAINS/INJURY 2015-12-10 17:10:52 NEW HANOVER REINDEER CT & DEAD END 1 EMS 17 12 3
1 40.258061 -75.264680 BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... 19446.0 EMS: DIABETIC EMERGENCY 2015-12-10 17:29:21 HATFIELD TOWNSHIP BRIAR PATH & WHITEMARSH LN 1 EMS 17 12 3
2 40.121182 -75.351975 HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... 19401.0 Fire: GAS-ODOR/LEAK 2015-12-10 14:39:21 NORRISTOWN HAWS AVE 1 Fire 14 12 3
3 40.116153 -75.343513 AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... 19401.0 EMS: CARDIAC EMERGENCY 2015-12-10 16:47:36 NORRISTOWN AIRY ST & SWEDE ST 1 EMS 16 12 3
4 40.251492 -75.603350 CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... NaN EMS: DIZZINESS 2015-12-10 16:56:52 LOWER POTTSGROVE CHERRYWOOD CT & DEAD END 1 EMS 16 12 3
5 40.253473 -75.283245 CANNON AVE & W 9TH ST; LANSDALE; Station 345;... 19446.0 EMS: HEAD INJURY 2015-12-10 15:39:04 LANSDALE CANNON AVE & W 9TH ST 1 EMS 15 12 3
6 40.182111 -75.127795 LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... 19044.0 EMS: NAUSEA/VOMITING 2015-12-10 16:46:48 HORSHAM LAUREL AVE & OAKDALE AVE 1 EMS 16 12 3
7 40.217286 -75.405182 COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... 19426.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 16:17:05 SKIPPACK COLLEGEVILLE RD & LYWISKI RD 1 EMS 16 12 3
8 40.289027 -75.399590 MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... 19438.0 EMS: SYNCOPAL EPISODE 2015-12-10 16:51:42 LOWER SALFORD MAIN ST & OLD SUMNEYTOWN PIKE 1 EMS 16 12 3
9 40.102398 -75.291458 BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... 19462.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:35:41 PLYMOUTH BLUEROUTE & RAMP I476 NB TO CHEMICAL RD 1 Traffic 17 12 3
10 40.231990 -75.251891 RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:33:50 MONTGOMERY RT202 PKWY & KNAPP RD 1 Traffic 17 12 3
11 40.084161 -75.308386 BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... 19428.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 16:32:10 PLYMOUTH BROOK RD & COLWELL LN 1 Traffic 16 12 3
12 40.174131 -75.098491 BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... 19040.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:15:49 UPPER MORELAND BYBERRY AVE & S WARMINSTER RD 1 Traffic 17 12 3
13 40.062974 -75.135914 OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... 19027.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:12:47 CHELTENHAM OLD YORK RD & VALLEY RD 1 Traffic 17 12 3
14 40.097222 -75.376195 SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:09:49 UPPER MERION SCHUYLKILL EXPY & CROTON RD UNDERPASS 1 Traffic 17 12 3
15 40.223778 -75.235399 STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... 18936.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:31:00 MONTGOMERY STUMP RD & WITCHWOOD DR 1 Traffic 17 12 3
16 40.243258 -75.286552 SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... 19446.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 17:42:44 LANSDALE SUSQUEHANNA AVE & W MAIN ST 1 EMS 17 12 3
17 40.312181 -75.574260 CHARLOTTE ST & MILES RD; NEW HANOVER; Station... 19525.0 EMS: DIZZINESS 2015-12-10 17:41:54 NEW HANOVER CHARLOTTE ST & MILES RD 1 EMS 17 12 3
18 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... 19401.0 EMS: VEHICLE ACCIDENT 2015-12-10 17:43:29 NORRISTOWN PENN ST & ARCH ST 1 EMS 17 12 3
19 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:45:23 HORSHAM COUNTY LINE RD & WILLOW DR 1 Traffic 17 12 3
20 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... 19401.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:43:45 NORRISTOWN PENN ST & ARCH ST 1 Traffic 17 12 3
21 40.117948 -75.209848 CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... 19031.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:53:22 WHITEMARSH CHURCH RD & REDCOAT DR 1 Traffic 17 12 3
22 40.199006 -75.300058 LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... 19446.0 Fire: APPLIANCE FIRE 2015-12-10 17:59:24 UPPER GWYNEDD LILAC CT & PRIMROSE DR 1 Fire 17 12 3
23 40.143326 -75.422819 RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... NaN Traffic: DISABLED VEHICLE - 2015-12-10 18:00:38 LOWER PROVIDENCE RT422 & PAWLINGS RD OVERPASS 1 Traffic 18 12 3
24 40.153268 -75.189558 SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:58:22 UPPER DUBLIN SUMMIT AVE & RT309 UNDERPASS 1 Traffic 17 12 3
25 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: GENERAL WEAKNESS 2015-12-10 18:02:02 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1 EMS 18 12 3
26 40.155283 -75.264230 PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... 19422.0 EMS: HEAD INJURY 2015-12-10 18:02:38 WHITPAIN PENLLYN BLUE BELL PIKE & VILLAGE CIR 1 EMS 18 12 3
27 40.028903 -75.351822 EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... 19085.0 Fire: CARBON MONOXIDE DETECTOR 2015-12-10 18:05:19 DELAWARE COUNTY EDENTON PL & DURHAM DR 1 Fire 18 12 3
28 40.097222 -75.376195 SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 18:05:39 UPPER MERION SCHUYLKILL EXPY & WEADLEY RD OVERPASS 1 Traffic 18 12 3
29 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 18:10:40 HORSHAM COUNTY LINE RD & WILLOW DR 1 Traffic 18 12 3
... ... ... ... ... ... ... ... ... ... ... ... ... ...
423879 40.284894 -75.583070 BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... 19525.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:18:15 NEW HANOVER BUCHERT RD & ROMIG RD 1 Traffic 8 11 4
423880 40.089043 -75.154857 RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... 19095.0 Traffic: ROAD OBSTRUCTION - 2018-11-16 08:18:08 CHELTENHAM RICES MILL RD & W CHURCH RD 1 Traffic 8 11 4
423881 40.188195 -75.195506 TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:17:59 HORSHAM TENNIS AVE & WELSH RD 1 Traffic 8 11 4
423882 40.188195 -75.195506 WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:14:32 UPPER DUBLIN WELSH RD & TENNIS AVE 1 Traffic 8 11 4
423883 40.175671 -75.125148 SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... 19044.0 EMS: SUBJECT IN PAIN 2018-11-16 08:27:45 HORSHAM SUMMIT AVE & RUTH AVE 1 EMS 8 11 4
423884 40.277468 -75.260462 BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... 19440.0 Fire: FIRE INVESTIGATION 2018-11-16 08:30:54 HATFIELD TOWNSHIP BETHLEHEM PIKE & TREWIGTOWN RD 1 Fire 8 11 4
423885 40.345292 -75.509276 HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... 18054.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:29:22 NEW HANOVER HENNING RD & HILL RD 1 Traffic 8 11 4
423886 40.260591 -75.503238 YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... 19473.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:30:00 LOWER FREDERICK YERGER RD & N RYANFORD RD 1 Traffic 8 11 4
423887 40.136020 -75.354606 BEECH DR & SPRUCE ST; WEST NORRITON; Station ... 19403.0 EMS: SEIZURES 2018-11-16 08:39:28 WEST NORRITON BEECH DR & SPRUCE ST 1 EMS 8 11 4
423888 40.230934 -75.522125 LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... 19468.0 Fire: FIRE ALARM 2018-11-16 08:39:53 LIMERICK LIGHTCAP RD & SANATOGA SPRINGS DR 1 Fire 8 11 4
423889 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER MORELAND MORELAND RD & BARTRAM RD 1 Traffic 8 11 4
423890 40.335354 -75.511268 HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... 18074.0 Fire: FIRE POLICE NEEDED 2018-11-16 08:45:04 NEW HANOVER HENNING RD 1 Fire 8 11 4
423891 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER MORELAND MORELAND RD & BARTRAM RD 1 Traffic 8 11 4
423892 40.107400 -75.113206 THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... 19046.0 Fire: FIRE ALARM 2018-11-16 08:49:48 ABINGTON THE FAIRWAY & RYDAL RD 1 Fire 8 11 4
423893 40.256628 -75.261270 LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... 19446.0 Fire: FIRE INVESTIGATION 2018-11-16 08:48:24 HATFIELD TOWNSHIP LINE ST & COWPATH RD 1 Fire 8 11 4
423894 40.183361 -75.542285 MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... 19468.0 EMS: FALL VICTIM 2018-11-16 08:50:58 ROYERSFORD MAIN ST & 2ND AVE 1 EMS 8 11 4
423895 40.184797 -75.286879 TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... 19422.0 EMS: SYNCOPAL EPISODE 2018-11-16 08:47:05 WHITPAIN TWIN SILO DR & MORRIS RD 1 EMS 8 11 4
423896 40.254344 -75.407617 HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; NaN Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 UPPER SALFORD HOFFMAN 1 Traffic 8 11 4
423897 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1 Traffic 8 11 4
423898 40.142797 -75.495065 MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... 19460.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:43:42 UPPER PROVIDENCE MAC DADE RD & SCARLET OAK DR 1 Traffic 8 11 4
423899 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1 Traffic 8 11 4
423900 40.157913 -75.203632 HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; 19002.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 AMBLER HOFFMAN 1 Traffic 8 11 4
423901 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: MEDICAL ALERT ALARM 2018-11-16 08:53:03 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1 EMS 8 11 4
423902 40.271663 -75.238440 RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... 18914.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:55:36 MONTGOMERY RICHARDSON RD & COUNTY LINE RD 1 Traffic 8 11 4
423903 40.235373 -75.224751 HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... 19454.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:54:52 MONTGOMERY HORSHAM RD & STUMP RD 1 Traffic 8 11 4
423904 40.139993 -75.049864 BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... 19006.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:08 LOWER MORELAND BUCK RD & WOODWARD DR 1 Traffic 8 11 4
423905 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:53:32 LOWER SALFORD OAK DR & MOYER RD 1 Traffic 8 11 4
423906 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:19 LOWER SALFORD OAK DR & MOYER RD 1 Traffic 8 11 4
423907 40.190946 -75.237285 SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:51:48 LOWER GWYNEDD SUMNEYTOWN PIKE & WELLINGTON DR 1 Traffic 8 11 4
423908 40.155164 -75.264665 HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; 19422.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 LOWER GWYNEDD HOFFMAN 1 Traffic 8 11 4

423909 rows × 13 columns

In [41]:
df["dates"] = df["timeStamp"].apply(lambda x:x.date())
In [42]:
df
Out[42]:
lat lng desc zip title timeStamp twp addr e short hour months day dates
0 40.297876 -75.581294 REINDEER CT & DEAD END; NEW HANOVER; Station ... 19525.0 EMS: BACK PAINS/INJURY 2015-12-10 17:10:52 NEW HANOVER REINDEER CT & DEAD END 1 EMS 17 12 3 2015-12-10
1 40.258061 -75.264680 BRIAR PATH & WHITEMARSH LN; HATFIELD TOWNSHIP... 19446.0 EMS: DIABETIC EMERGENCY 2015-12-10 17:29:21 HATFIELD TOWNSHIP BRIAR PATH & WHITEMARSH LN 1 EMS 17 12 3 2015-12-10
2 40.121182 -75.351975 HAWS AVE; NORRISTOWN; 2015-12-10 @ 14:39:21-St... 19401.0 Fire: GAS-ODOR/LEAK 2015-12-10 14:39:21 NORRISTOWN HAWS AVE 1 Fire 14 12 3 2015-12-10
3 40.116153 -75.343513 AIRY ST & SWEDE ST; NORRISTOWN; Station 308A;... 19401.0 EMS: CARDIAC EMERGENCY 2015-12-10 16:47:36 NORRISTOWN AIRY ST & SWEDE ST 1 EMS 16 12 3 2015-12-10
4 40.251492 -75.603350 CHERRYWOOD CT & DEAD END; LOWER POTTSGROVE; S... NaN EMS: DIZZINESS 2015-12-10 16:56:52 LOWER POTTSGROVE CHERRYWOOD CT & DEAD END 1 EMS 16 12 3 2015-12-10
5 40.253473 -75.283245 CANNON AVE & W 9TH ST; LANSDALE; Station 345;... 19446.0 EMS: HEAD INJURY 2015-12-10 15:39:04 LANSDALE CANNON AVE & W 9TH ST 1 EMS 15 12 3 2015-12-10
6 40.182111 -75.127795 LAUREL AVE & OAKDALE AVE; HORSHAM; Station 35... 19044.0 EMS: NAUSEA/VOMITING 2015-12-10 16:46:48 HORSHAM LAUREL AVE & OAKDALE AVE 1 EMS 16 12 3 2015-12-10
7 40.217286 -75.405182 COLLEGEVILLE RD & LYWISKI RD; SKIPPACK; Stati... 19426.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 16:17:05 SKIPPACK COLLEGEVILLE RD & LYWISKI RD 1 EMS 16 12 3 2015-12-10
8 40.289027 -75.399590 MAIN ST & OLD SUMNEYTOWN PIKE; LOWER SALFORD;... 19438.0 EMS: SYNCOPAL EPISODE 2015-12-10 16:51:42 LOWER SALFORD MAIN ST & OLD SUMNEYTOWN PIKE 1 EMS 16 12 3 2015-12-10
9 40.102398 -75.291458 BLUEROUTE & RAMP I476 NB TO CHEMICAL RD; PLYM... 19462.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:35:41 PLYMOUTH BLUEROUTE & RAMP I476 NB TO CHEMICAL RD 1 Traffic 17 12 3 2015-12-10
10 40.231990 -75.251891 RT202 PKWY & KNAPP RD; MONTGOMERY; 2015-12-10 ... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:33:50 MONTGOMERY RT202 PKWY & KNAPP RD 1 Traffic 17 12 3 2015-12-10
11 40.084161 -75.308386 BROOK RD & COLWELL LN; PLYMOUTH; 2015-12-10 @ ... 19428.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 16:32:10 PLYMOUTH BROOK RD & COLWELL LN 1 Traffic 16 12 3 2015-12-10
12 40.174131 -75.098491 BYBERRY AVE & S WARMINSTER RD; UPPER MORELAND;... 19040.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:15:49 UPPER MORELAND BYBERRY AVE & S WARMINSTER RD 1 Traffic 17 12 3 2015-12-10
13 40.062974 -75.135914 OLD YORK RD & VALLEY RD; CHELTENHAM; 2015-12-1... 19027.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:12:47 CHELTENHAM OLD YORK RD & VALLEY RD 1 Traffic 17 12 3 2015-12-10
14 40.097222 -75.376195 SCHUYLKILL EXPY & CROTON RD UNDERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:09:49 UPPER MERION SCHUYLKILL EXPY & CROTON RD UNDERPASS 1 Traffic 17 12 3 2015-12-10
15 40.223778 -75.235399 STUMP RD & WITCHWOOD DR; MONTGOMERY; 2015-12-1... 18936.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:31:00 MONTGOMERY STUMP RD & WITCHWOOD DR 1 Traffic 17 12 3 2015-12-10
16 40.243258 -75.286552 SUSQUEHANNA AVE & W MAIN ST; LANSDALE; Statio... 19446.0 EMS: RESPIRATORY EMERGENCY 2015-12-10 17:42:44 LANSDALE SUSQUEHANNA AVE & W MAIN ST 1 EMS 17 12 3 2015-12-10
17 40.312181 -75.574260 CHARLOTTE ST & MILES RD; NEW HANOVER; Station... 19525.0 EMS: DIZZINESS 2015-12-10 17:41:54 NEW HANOVER CHARLOTTE ST & MILES RD 1 EMS 17 12 3 2015-12-10
18 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; Station 308A; ... 19401.0 EMS: VEHICLE ACCIDENT 2015-12-10 17:43:29 NORRISTOWN PENN ST & ARCH ST 1 EMS 17 12 3 2015-12-10
19 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:45:23 HORSHAM COUNTY LINE RD & WILLOW DR 1 Traffic 17 12 3 2015-12-10
20 40.114239 -75.338508 PENN ST & ARCH ST; NORRISTOWN; 2015-12-10 @ 17... 19401.0 Traffic: VEHICLE ACCIDENT - 2015-12-10 17:43:45 NORRISTOWN PENN ST & ARCH ST 1 Traffic 17 12 3 2015-12-10
21 40.117948 -75.209848 CHURCH RD & REDCOAT DR; WHITEMARSH; 2015-12-10... 19031.0 Traffic: DISABLED VEHICLE - 2015-12-10 17:53:22 WHITEMARSH CHURCH RD & REDCOAT DR 1 Traffic 17 12 3 2015-12-10
22 40.199006 -75.300058 LILAC CT & PRIMROSE DR; UPPER GWYNEDD; 2015-12... 19446.0 Fire: APPLIANCE FIRE 2015-12-10 17:59:24 UPPER GWYNEDD LILAC CT & PRIMROSE DR 1 Fire 17 12 3 2015-12-10
23 40.143326 -75.422819 RT422 & PAWLINGS RD OVERPASS; LOWER PROVIDENC... NaN Traffic: DISABLED VEHICLE - 2015-12-10 18:00:38 LOWER PROVIDENCE RT422 & PAWLINGS RD OVERPASS 1 Traffic 18 12 3 2015-12-10
24 40.153268 -75.189558 SUMMIT AVE & RT309 UNDERPASS; UPPER DUBLIN; 20... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 17:58:22 UPPER DUBLIN SUMMIT AVE & RT309 UNDERPASS 1 Traffic 17 12 3 2015-12-10
25 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: GENERAL WEAKNESS 2015-12-10 18:02:02 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1 EMS 18 12 3 2015-12-10
26 40.155283 -75.264230 PENLLYN BLUE BELL PIKE & VILLAGE CIR; WHITPAI... 19422.0 EMS: HEAD INJURY 2015-12-10 18:02:38 WHITPAIN PENLLYN BLUE BELL PIKE & VILLAGE CIR 1 EMS 18 12 3 2015-12-10
27 40.028903 -75.351822 EDENTON PL & DURHAM DR; DELAWARE COUNTY; 2015-... 19085.0 Fire: CARBON MONOXIDE DETECTOR 2015-12-10 18:05:19 DELAWARE COUNTY EDENTON PL & DURHAM DR 1 Fire 18 12 3 2015-12-10
28 40.097222 -75.376195 SCHUYLKILL EXPY & WEADLEY RD OVERPASS; UPPER M... NaN Traffic: VEHICLE ACCIDENT - 2015-12-10 18:05:39 UPPER MERION SCHUYLKILL EXPY & WEADLEY RD OVERPASS 1 Traffic 18 12 3 2015-12-10
29 40.209337 -75.135266 COUNTY LINE RD & WILLOW DR; HORSHAM; 2015-12-1... 18974.0 Traffic: DISABLED VEHICLE - 2015-12-10 18:10:40 HORSHAM COUNTY LINE RD & WILLOW DR 1 Traffic 18 12 3 2015-12-10
... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
423879 40.284894 -75.583070 BUCHERT RD & ROMIG RD; NEW HANOVER; 2018-11-16... 19525.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:18:15 NEW HANOVER BUCHERT RD & ROMIG RD 1 Traffic 8 11 4 2018-11-16
423880 40.089043 -75.154857 RICES MILL RD & W CHURCH RD; CHELTENHAM; 2018-... 19095.0 Traffic: ROAD OBSTRUCTION - 2018-11-16 08:18:08 CHELTENHAM RICES MILL RD & W CHURCH RD 1 Traffic 8 11 4 2018-11-16
423881 40.188195 -75.195506 TENNIS AVE & WELSH RD; HORSHAM; 2018-11-16 @ 0... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:17:59 HORSHAM TENNIS AVE & WELSH RD 1 Traffic 8 11 4 2018-11-16
423882 40.188195 -75.195506 WELSH RD & TENNIS AVE; UPPER DUBLIN; 2018-11-1... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:14:32 UPPER DUBLIN WELSH RD & TENNIS AVE 1 Traffic 8 11 4 2018-11-16
423883 40.175671 -75.125148 SUMMIT AVE & RUTH AVE; HORSHAM; Station 352; ... 19044.0 EMS: SUBJECT IN PAIN 2018-11-16 08:27:45 HORSHAM SUMMIT AVE & RUTH AVE 1 EMS 8 11 4 2018-11-16
423884 40.277468 -75.260462 BETHLEHEM PIKE & TREWIGTOWN RD; HATFIELD TOWNS... 19440.0 Fire: FIRE INVESTIGATION 2018-11-16 08:30:54 HATFIELD TOWNSHIP BETHLEHEM PIKE & TREWIGTOWN RD 1 Fire 8 11 4 2018-11-16
423885 40.345292 -75.509276 HENNING RD & HILL RD; NEW HANOVER; 2018-11-16 ... 18054.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:29:22 NEW HANOVER HENNING RD & HILL RD 1 Traffic 8 11 4 2018-11-16
423886 40.260591 -75.503238 YERGER RD & N RYANFORD RD; LOWER FREDERICK; 20... 19473.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:30:00 LOWER FREDERICK YERGER RD & N RYANFORD RD 1 Traffic 8 11 4 2018-11-16
423887 40.136020 -75.354606 BEECH DR & SPRUCE ST; WEST NORRITON; Station ... 19403.0 EMS: SEIZURES 2018-11-16 08:39:28 WEST NORRITON BEECH DR & SPRUCE ST 1 EMS 8 11 4 2018-11-16
423888 40.230934 -75.522125 LIGHTCAP RD & SANATOGA SPRINGS DR; LIMERICK; 2... 19468.0 Fire: FIRE ALARM 2018-11-16 08:39:53 LIMERICK LIGHTCAP RD & SANATOGA SPRINGS DR 1 Fire 8 11 4 2018-11-16
423889 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER MORELAND MORELAND RD & BARTRAM RD 1 Traffic 8 11 4 2018-11-16
423890 40.335354 -75.511268 HENNING RD; NEW HANOVER; 2018-11-16 @ 08:45:04... 18074.0 Fire: FIRE POLICE NEEDED 2018-11-16 08:45:04 NEW HANOVER HENNING RD 1 Fire 8 11 4 2018-11-16
423891 40.150675 -75.132652 MORELAND RD & BARTRAM RD; UPPER MORELAND; 2018... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER MORELAND MORELAND RD & BARTRAM RD 1 Traffic 8 11 4 2018-11-16
423892 40.107400 -75.113206 THE FAIRWAY & RYDAL RD; ABINGTON; 2018-11-16 ... 19046.0 Fire: FIRE ALARM 2018-11-16 08:49:48 ABINGTON THE FAIRWAY & RYDAL RD 1 Fire 8 11 4 2018-11-16
423893 40.256628 -75.261270 LINE ST & COWPATH RD; HATFIELD TOWNSHIP; 2018-... 19446.0 Fire: FIRE INVESTIGATION 2018-11-16 08:48:24 HATFIELD TOWNSHIP LINE ST & COWPATH RD 1 Fire 8 11 4 2018-11-16
423894 40.183361 -75.542285 MAIN ST & 2ND AVE; ROYERSFORD; Station 325; 2... 19468.0 EMS: FALL VICTIM 2018-11-16 08:50:58 ROYERSFORD MAIN ST & 2ND AVE 1 EMS 8 11 4 2018-11-16
423895 40.184797 -75.286879 TWIN SILO DR & MORRIS RD; WHITPAIN; Station 3... 19422.0 EMS: SYNCOPAL EPISODE 2018-11-16 08:47:05 WHITPAIN TWIN SILO DR & MORRIS RD 1 EMS 8 11 4 2018-11-16
423896 40.254344 -75.407617 HOFFMAN ; UPPER SALFORD; 2018-11-16 @ 08:46:25; NaN Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 UPPER SALFORD HOFFMAN 1 Traffic 8 11 4 2018-11-16
423897 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:46:39 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1 Traffic 8 11 4 2018-11-16
423898 40.142797 -75.495065 MAC DADE RD & SCARLET OAK DR; UPPER PROVIDENCE... 19460.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:43:42 UPPER PROVIDENCE MAC DADE RD & SCARLET OAK DR 1 Traffic 8 11 4 2018-11-16
423899 40.149952 -75.134537 W MORELAND RD & KIMBALL AVE; UPPER DUBLIN; 201... 19090.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:38:23 UPPER DUBLIN W MORELAND RD & KIMBALL AVE 1 Traffic 8 11 4 2018-11-16
423900 40.157913 -75.203632 HOFFMAN ; AMBLER; 2018-11-16 @ 08:46:25; 19002.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 AMBLER HOFFMAN 1 Traffic 8 11 4 2018-11-16
423901 40.133037 -75.408463 SHANNONDELL DR & SHANNONDELL BLVD; LOWER PROV... 19403.0 EMS: MEDICAL ALERT ALARM 2018-11-16 08:53:03 LOWER PROVIDENCE SHANNONDELL DR & SHANNONDELL BLVD 1 EMS 8 11 4 2018-11-16
423902 40.271663 -75.238440 RICHARDSON RD & COUNTY LINE RD; MONTGOMERY; 20... 18914.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:55:36 MONTGOMERY RICHARDSON RD & COUNTY LINE RD 1 Traffic 8 11 4 2018-11-16
423903 40.235373 -75.224751 HORSHAM RD & STUMP RD; MONTGOMERY; 2018-11-16 ... 19454.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:54:52 MONTGOMERY HORSHAM RD & STUMP RD 1 Traffic 8 11 4 2018-11-16
423904 40.139993 -75.049864 BUCK RD & WOODWARD DR; LOWER MORELAND; 2018-11... 19006.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:08 LOWER MORELAND BUCK RD & WOODWARD DR 1 Traffic 8 11 4 2018-11-16
423905 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:53:32 LOWER SALFORD OAK DR & MOYER RD 1 Traffic 8 11 4 2018-11-16
423906 40.270121 -75.382825 OAK DR & MOYER RD; LOWER SALFORD; 2018-11-16 @... 19438.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:54:19 LOWER SALFORD OAK DR & MOYER RD 1 Traffic 8 11 4 2018-11-16
423907 40.190946 -75.237285 SUMNEYTOWN PIKE & WELLINGTON DR; LOWER GWYNEDD... 19002.0 Traffic: VEHICLE ACCIDENT - 2018-11-16 08:51:48 LOWER GWYNEDD SUMNEYTOWN PIKE & WELLINGTON DR 1 Traffic 8 11 4 2018-11-16
423908 40.155164 -75.264665 HOFFMAN ; LOWER GWYNEDD; 2018-11-16 @ 08:46:25; 19422.0 Traffic: DISABLED VEHICLE - 2018-11-16 08:46:25 LOWER GWYNEDD HOFFMAN 1 Traffic 8 11 4 2018-11-16

423909 rows × 14 columns

In [102]:
df.groupby("dates").count()["lat"].plot()
plt.tight_layout(rect=[0, 0.02, 3, 1.5])
In [101]:
df[df["short"]=="EMS"].groupby("dates").count()["lat"].plot()
plt.title("EMS")
plt.tight_layout(rect=[0, 0.02, 3, 1.5])
In [99]:
df[df["short"]=="Traffic"].groupby("dates").count()["lat"].plot()
plt.title("Traffic")
plt.tight_layout(rect=[0, 0.02, 3, 1.5])
In [100]:
df[df["short"]=="Fire"].groupby("dates").count()["lat"].plot()
plt.title("Fire")
plt.tight_layout(rect=[0, 0.02, 3, 1.5])
In [86]:
df["short"].iplot(kind="hist",bins=50, colorscale="rdylbu")
plt.tight_layout(rect=[0, 0.02, 3, 1])
<matplotlib.figure.Figure at 0x294ccda34a8>

THE END